[dbo].[BAEZipCodesLoad]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@ZipCode	int	4

create procedure [dbo].[BAEZipCodesLoad] @ZipCode as
int
AS
    SELECT *
    FROM Zip_Code
    WHERE ZIP = @ZipCode;

GO